﻿using System;
using System.Data;
using WP.Commons;

namespace WP.RM.DataEntity
{
    //=========MCity  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class RMProductDEL : DataSet, IDataEntity
    {
          //=========mCity ============================
        public const string TABLENAME_RMProduct = "rmProduct";

        public const string RECID = "RecId";
        public const string CategoryID = "CategoryID";
        public const string CategoryName = "CategoryName";
        public const string SetID = "SetID";
        public const string SetName = "SetName";
        public const string ProductLength = "Productlength";
        public const string ProductWidth = "ProductWidth";
        public const string ProductID = "ProductID";
        public const string ProductFItemID = "ProductFItemID";
        public const string ProductName = "ProductName";
        public const string RECSTAMP = "RecStamp";
        public const string Pages="Pages";
        public const string Remark = "Remark";
        public const string PaperHeight = "PaperHeight";
        public const string SetSize = "SetSize";
        public const string Quantity = "Quantity";
         public const string Ver="Ver";
         public const string LabelUnitQty="LabelUnitQty";
          public const string LabelLength="LabelLength";
          public const string LabelWidth="LabelWidth";
          public const string PrintLength="PrintLength";
          public const string PrintWidth="PrintWidth";
          public const string LaminatingLength="LaminatingLength";
          public const string LaminatingWidth="LaminatingWidth";
          public const string CutFactor="CutFactor";
          public const string PrintUseQty="PrintUseQty";
          public const string ContainQty="ContainQty";
          public const string PackageQty="PackageQty";
          public const string InnerDiameterLength="InnerDiameterLength";
          public const string InnerDiameterWidth="InnerDiameterWidth";
          public const string InnerDiameterHeight="InnerDiameterHeight";
          public const string InnerOutsideDiff="InnerOutsideDiff";
          public const string MiddleWidth="MiddleWidth";
          public const string BurrWidth="BurrWidth";
          public const string OtherPrintWidth="OtherPrintWidth";
          public const string OtherPrintBackWidth="OtherPrintBackWidth";
          public const string UseIronNailQty="UseIronNailQty";
          public const string LockingWireQty="LockingWireQty";
          public const string LockingWireLength = "LockingWireLength";
          public const string LabelSize = "LabelSize";
          public const string KDCode = "KDCode";
        
        public const string PagePrintLength="PagePrintLength";
        public const string PagePrintWidth = "PagePrintWidth";

        public const string ProdDiameter = "ProdDiameter";
        
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public RMProductDEL()
        {
            //Create mCity structure
            CreatemCityStructure();
        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_RMProduct);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(ProductFItemID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(ProductLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(Pages, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductID, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProductName, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(Remark, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CategoryID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);


            DC = new DataColumn(CategoryName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(KDCode , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);


            DC = new DataColumn(SetSize, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PaperHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(Ver, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(LabelUnitQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LabelLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LabelWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PrintLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LabelSize , typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PrintWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LaminatingLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LaminatingWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CutFactor, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PrintUseQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ContainQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PackageQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerDiameterLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerDiameterWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerDiameterHeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(InnerOutsideDiff, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(MiddleWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(BurrWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OtherPrintWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(OtherPrintBackWidth, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(UseIronNailQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LockingWireQty, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(LockingWireLength, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(Quantity , typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PagePrintLength , typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PagePrintWidth , typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(ProdDiameter, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            


            this.Tables.Add(table);
        }


    }
}
